<?php session_start();?>
<?php include('includes/header.php');?>
<?php include("../includes/config.php"); ?>
 <?php if (isset($_POST['elm1'])){
		$query = "UPDATE cities
					   SET article_text  =  '".$_POST['elm1']."',
					   article = 1
					   where id_city = ".$_GET['editCity'];
						
		$exc = mysql_query($query) or die (mysql_error());
		echo "Artikel toegevoegd";
		header('Location: steden.php',2); }?>
	<script type="text/javascript" src="http://www.google.com/jsapi"></script>
	<script type="text/javascript">
		google.load("jquery", "1");
	</script>

	<!-- Load TinyMCE -->
	<script type="text/javascript" src="jscripts/tiny_mce/jquery.tinymce.js"></script>
	<script type="text/javascript">
		$().ready(function() {
			$('textarea.tinymce').tinymce({
				// Location of TinyMCE script
				script_url : 'jscripts/tiny_mce/tiny_mce.js',

				// General options
				theme : "advanced",
				plugins : "autolink,lists,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,advlist",

				// Theme options
				theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",
				theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",
				theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",
				theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak",
				theme_advanced_toolbar_location : "top",
				theme_advanced_toolbar_align : "left",
				theme_advanced_statusbar_location : "bottom",
				theme_advanced_resizing : true,

				// Example content CSS (should be your site CSS)
				content_css : "css/content.css",

				// Drop lists for link/image/media/template dialogs
				template_external_list_url : "lists/template_list.js",
				external_link_list_url : "lists/link_list.js",
				external_image_list_url : "lists/image_list.js",
				media_external_list_url : "lists/media_list.js",

				// Replace values for the template plugin
				template_replace_values : {
					username : "Some User",
					staffid : "991234"
				}
			});
		});
	</script>
	<!-- /TinyMCE -->
  <div  id="main" role="main">

  <?php if(isset($_GET['editCity'])){
	?>
	
		<form method="post" action="#">
		<div>
		<?php $q = "select city_name,article_text from cities where id_city = ".$_GET['editCity'];
				  $res = mysql_fetch_array(mysql_query($q)); ?>

			<h2>Pagina wijzigen voor <?php echo $res['city_name']; ?></h2>

			<!-- Gets replaced with TinyMCE, remember HTML in a textarea should be encoded -->
			<div>
				<textarea id="elm1" name="elm1" rows="15" cols="80" style="width: 80%" class="tinymce">
					<?php echo $res['article_text']; ?>
				</textarea>
			</div>

			<!-- Some integration calls 
			<a href="javascript:;" onclick="$('#elm1').tinymce().show();return false;">[Show]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().hide();return false;">[Hide]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().execCommand('Bold');return false;">[Bold]</a>
			<a href="javascript:;" onclick="alert($('#elm1').html());return false;">[Get contents]</a>
			<a href="javascript:;" onclick="alert($('#elm1').tinymce().selection.getContent());return false;">[Get selected HTML]</a>
			<a href="javascript:;" onclick="alert($('#elm1').tinymce().selection.getContent({format : 'text'}));return false;">[Get selected text]</a>
			<a href="javascript:;" onclick="alert($('#elm1').tinymce().selection.getNode().nodeName);return false;">[Get selected element]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().execCommand('mceInsertContent',false,'<b>Hello world!!</b>');return false;">[Insert HTML]</a>
			<a href="javascript:;" onclick="$('#elm1').tinymce().execCommand('mceReplaceContent',false,'<b>{$selection}</b>');return false;">[Replace selection]</a>
	-->
			<br />
			<input type="submit" name="save" value="Bevestig" />
			<input type="reset" name="reset" value="Reset" />
		</div>
	</form>
	<script type="text/javascript">
	if (document.location.protocol == 'file:') {
		alert("The examples might not work properly on the local file system due to security settings in your browser. Please use a real webserver.");
	}
	</script>

  </div>
	<?php

  }
  else{
   if (isset($_GET['deleteCity'])){
	mysql_query("delete from cities where id_city = ".$_GET['deleteCity']) or die(mysql_error());
	}
  ?>
		<h1>Nieuwe steden toevoegen</h1>
		<?php 
			$query = "select * from countries";
			$result = mysql_query($query) or die (mysql_error());
			
			echo '<form method="GET" action="nieuwArtikel.php">';
			echo "<select  name=\"land\" class=\"landenlijst\" id=\"landenlijst\"  onchange=\"returnCity()\">";
			echo "<option>Selecteer land</option>";
		
			while ($country = mysql_fetch_array($result)){
				echo "<option  onchange=\"returnCity(this.val)\" value='".$country['id_country']."'>".$country['country_name']."</option>";
			}
			echo "</select>"; 
		?>
		<div id ="selectCity"></div>
		<br class="clear"/>
		</form>
		<div id="steden">
		<h1>Huidige steden</h1>
		<table id="huidigeSteden" style="border-collapse:separate; border-spacing:10px;">
				<tr style="font-weight:bold;"><td>Stad</td><td>Populair</td><td>Edit</td><td>Verwijder</td></tr>
				<?php 
					$query = "SELECT C.country_name,id_city, X.city_name,populair FROM cities as X
									JOIN countries as C
									ON X.id_country = C.id_country 
									AND article = 1";
									
					$result = mysql_query($query);
					while ($city = mysql_fetch_array($result)){
						echo "<tr><td>".$city['city_name']."</td>";
						
						if($city['populair'] == 1){
							echo '<td><input onclick="makePopular(0,'.$city['id_city'].')" type="checkbox" checked="yes"/></td>';
						}else{
							echo '<td><input  onclick="makePopular(1,'.$city['id_city'].')" type="checkbox"/></td>';
						}
						echo '<td><a href="?editCity='.$city['id_city'].'"><img src="http://cdn1.iconfinder.com/data/icons/diagona/icon/10/018.png"/></a></td>';
						echo '<td><a href="?deleteCity='.$city['id_city'].'"><img  src="http://cdn1.iconfinder.com/data/icons/diagona/icon/10/101.png"/></a></td></tr>';
						
					}
					
				?>
				
		 </table>
<?php } ?>		
  </div>

  <?php include('includes/footer.php');?>